Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Operations Management-Assignment 5

Operations Management-Assignment 5

Q Select a business operations dataset from the internet or other sources which can be used for forecasting in the University Library. Develop a minimum of three quantitative forecasts using Microsoft®Excel. • Compare and contrast each quantitative forecast you develop. • Choose the one forecast you determine would be the best for the firm and be prepared to explain why you chose this. • Evaluate the impact this forecast would have on the firm from a financial metrics standpoint. Develop a 700-word report in which you describe your forecasting project including details on all the assignment steps.

View Related Questions

Solution Preview

For this assignment, I have selected Wal-Mart as the company of interest. I have taken the company’s net sales data from 2006 to 2017, and then have used three different forecasting techniques to forecast the sales data of 2018 ("Walmart's net sales worldwide from 2006 to 2018 (in billion U.S. dollars)", 2019). The three chosen techniques are the moving average, the exponential smoothing and the regression forecasting.